[dbo].[WorkflowService]

Property	Value
Created	10:31:44 AM Tuesday, March 02, 2010
Last Modified	1:17:35 PM Thursday, February 23, 2012

	Name	Data Type	Max Length (Bytes)	Default
	WorkflowServiceKey	uniqueidentifier	16	(newid())
$Indexes IX_WorkflowService_MachineName_ServiceName: MachineName\ServiceName$	MachineName	nvarchar(100)	200
$Indexes IX_WorkflowService_MachineName_ServiceName: MachineName\ServiceName$	ServiceName	nvarchar(100)	200
	WorkFlowServiceStatusCode	nvarchar(25)	50
	BaseDirectory	nvarchar(500)	1000
	MaxWorkerCount	int	4
	CategoryFilter	nvarchar(50)	100
	UpdatedOn	datetime	8
	MarkedForDeleteOn	datetime	8

	Name	Columns	Unique
	PK_WorkflowService	WorkflowServiceKey
	IX_WorkflowService_MachineName_ServiceName	MachineName, ServiceName
	IX_WorkflowService_WorkFlowServiceStatusCode	WorkFlowServiceStatusCode

Name	Columns
FK_WorkflowStatus_ServiceStatusRef	WorkFlowServiceStatusCode->[dbo].[ServiceStatusRef].[ServiceStatusCode]

SQL Script

CREATE TABLE [dbo].[WorkflowService]
(
[WorkflowServiceKey] [uniqueidentifier] NOT NULL CONSTRAINT [DF_WorkflowService_WorkflowServiceKey] DEFAULT (newid()),
[MachineName] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ServiceName] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[WorkFlowServiceStatusCode] [nvarchar] (25) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[BaseDirectory] [nvarchar] (500) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[MaxWorkerCount] [int] NULL,
[CategoryFilter] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[UpdatedOn] [datetime] NOT NULL,
[MarkedForDeleteOn] [datetime] NULL
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[WorkflowService] ADD CONSTRAINT [PK_WorkflowService] PRIMARY KEY CLUSTERED ([WorkflowServiceKey]) ON [PRIMARY]
GO
CREATE UNIQUE NONCLUSTERED INDEX [IX_WorkflowService_MachineName_ServiceName] ON [dbo].[WorkflowService] ([MachineName], [ServiceName]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_WorkflowService_WorkFlowServiceStatusCode] ON [dbo].[WorkflowService] ([WorkFlowServiceStatusCode]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[WorkflowService] ADD CONSTRAINT [FK_WorkflowStatus_ServiceStatusRef] FOREIGN KEY ([WorkFlowServiceStatusCode]) REFERENCES [dbo].[ServiceStatusRef] ([ServiceStatusCode])
GO